<template>
    <div class="app-container">
        <el-form :model="queryParams" ref="queryRef" :inline="true" v-show="showSearch" label-width="68px">
                        <el-form-item label="储存过程名称" prop="procedureName">
                            <el-input
                                    v-model="queryParams.procedureName"
                                    placeholder="请输入储存过程名称"
                                    clearable
                                    @keyup.enter="handleQuery"
                            />
                        </el-form-item>
                        <el-form-item label="开始时间" prop="startTime">
                            <el-date-picker clearable
                                            v-model="queryParams.startTime"
                                            type="date"
                                            value-format="YYYY-MM-DD"
                                            placeholder="请选择开始时间">
                            </el-date-picker>
                        </el-form-item>
                        <el-form-item label="结束时间" prop="endTime">
                            <el-date-picker clearable
                                            v-model="queryParams.endTime"
                                            type="date"
                                            value-format="YYYY-MM-DD"
                                            placeholder="请选择结束时间">
                            </el-date-picker>
                        </el-form-item>
                        <el-form-item label="执行结果" prop="resultCode">
                            <el-input
                                    v-model="queryParams.resultCode"
                                    placeholder="请输入执行结果"
                                    clearable
                                    @keyup.enter="handleQuery"
                            />
                        </el-form-item>
                        <el-form-item label="创建时间" prop="createTime">
                            <el-date-picker clearable
                                            v-model="queryParams.createTime"
                                            type="date"
                                            value-format="YYYY-MM-DD"
                                            placeholder="请选择创建时间">
                            </el-date-picker>
                        </el-form-item>
            <el-form-item>
                <el-button type="primary" icon="Search" @click="handleQuery">搜索</el-button>
                <el-button icon="Refresh" @click="resetQuery">重置</el-button>
            </el-form-item>
        </el-form>

        <el-row :gutter="10" class="mb8">
            <el-col :span="1.5">
                <el-button
                        type="primary"
                        plain
                        icon="Plus"
                        @click="handleAdd"
                        v-hasPermi="['system:procedure:add']"
                >新增</el-button>
            </el-col>
            <el-col :span="1.5">
                <el-button
                        type="success"
                        plain
                        icon="Edit"
                        :disabled="single"
                        @click="handleUpdate"
                        v-hasPermi="['system:procedure:edit']"
                >修改</el-button>
            </el-col>
            <el-col :span="1.5">
                <el-button
                        type="danger"
                        plain
                        icon="Delete"
                        :disabled="multiple"
                        @click="handleDelete"
                        v-hasPermi="['system:procedure:remove']"
                >删除</el-button>
            </el-col>
            <el-col :span="1.5">
                <el-button
                        type="warning"
                        plain
                        icon="Download"
                        @click="handleExport"
                        v-hasPermi="['system:procedure:export']"
                >导出</el-button>
            </el-col>
            <right-toolbar v-model:showSearch="showSearch" @queryTable="getList"></right-toolbar>
        </el-row>

        <el-table v-loading="loading" :data="procedureList" @selection-change="handleSelectionChange" style="height: calc(100% - 130px);">
            <el-table-column type="selection" width="55" align="center" />
                    <el-table-column label="储存过程名称" align="center" prop="procedureName" />
                    <el-table-column label="步骤" align="center" prop="step" />
                    <el-table-column label="开始时间" align="center" prop="startTime" width="180" />
                    <el-table-column label="结束时间" align="center" prop="endTime" width="180" />
                    <el-table-column label="执行结果" align="center" prop="resultCode" />
                    <el-table-column label="创建时间" align="center" prop="createTime" width="180" />
            <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
                <template #default="scope">
                    <el-button link type="primary" icon="Edit" @click="handleUpdate(scope.row)" v-hasPermi="['system:procedure:edit']">修改</el-button>
                    <el-button link type="primary" icon="Delete" @click="handleDelete(scope.row)" v-hasPermi="['system:procedure:remove']">删除</el-button>
                </template>
            </el-table-column>
        </el-table>

        <pagination
                v-show="total>0"
                :total="total"
                v-model:page="queryParams.pageNum"
                v-model:limit="queryParams.pageSize"
                @pagination="getList"
        />

        <!-- 添加或修改储存过程步骤分布处理日志对话框 -->
        <el-dialog :title="title" v-model="open" width="500px" append-to-body>
            <el-form ref="procedureRef" :model="form" :rules="rules" label-width="80px">
            </el-form>
            <template #footer>
                <div class="dialog-footer">
                    <el-button type="primary" @click="submitForm">确 定</el-button>
                    <el-button @click="cancel">取 消</el-button>
                </div>
            </template>
        </el-dialog>
    </div>
</template>

<script setup name="Procedure">
  import { listProcedure, getProcedure, delProcedure, addProcedure, updateProcedure } from "@/api/monitor/procedure"

  const { proxy } = getCurrentInstance()

  const procedureList = ref([])
  const open = ref(false)
  const loading = ref(true)
  const showSearch = ref(true)
  const ids = ref([])
  const single = ref(true)
  const multiple = ref(true)
  const total = ref(0)
  const title = ref("")

  const data = reactive({
    form: {},
    queryParams: {
      pageNum: 1,
      pageSize: 20,
      procedureName: null,
      step: null,
      startTime: null,
      endTime: null,
      resultCode: null,
      createTime: null
    },
    rules: {
      procedureName: [
        { required: true, message: "储存过程名称不能为空", trigger: "blur" }
      ]
    }
  })

  const { queryParams, form, rules } = toRefs(data)

  /** 查询储存过程步骤分布处理日志列表 */
  function getList() {
    loading.value = true
    listProcedure(queryParams.value).then(response => {
      procedureList.value = response.rows
      total.value = response.total
      loading.value = false
    })
  }

  // 取消按钮
  function cancel() {
    open.value = false
    reset()
  }

  // 表单重置
  function reset() {
    form.value = {
      procedureName: null,
      step: null,
      startTime: null,
      endTime: null,
      resultCode: null,
      createTime: null
    }
    proxy.resetForm("procedureRef")
  }

  /** 搜索按钮操作 */
  function handleQuery() {
    queryParams.value.pageNum = 1
    getList()
  }

  /** 重置按钮操作 */
  function resetQuery() {
    proxy.resetForm("queryRef")
    handleQuery()
  }

  // 多选框选中数据
  function handleSelectionChange(selection) {
    ids.value = selection.map(item => item.procedureName)
    single.value = selection.length != 1
    multiple.value = !selection.length
  }

  /** 新增按钮操作 */
  function handleAdd() {
    reset()
    open.value = true
    title.value = "添加储存过程步骤分布处理日志"
  }

  /** 修改按钮操作 */
  function handleUpdate(row) {
    reset()
    const _procedureName = row.procedureName || ids.value
    getProcedure(_procedureName).then(response => {
      form.value = response.data
      open.value = true
      title.value = "修改储存过程步骤分布处理日志"
    })
  }

  /** 提交按钮 */
  function submitForm() {
    proxy.$refs["procedureRef"].validate(valid => {
      if (valid) {
        if (form.value.procedureName != null) {
          updateProcedure(form.value).then(response => {
            proxy.$modal.msgSuccess("修改成功")
            open.value = false
            getList()
          })
        } else {
          addProcedure(form.value).then(response => {
            proxy.$modal.msgSuccess("新增成功")
            open.value = false
            getList()
          })
        }
      }
    })
  }

  /** 删除按钮操作 */
  function handleDelete(row) {
    const _procedureNames = row.procedureName || ids.value
    proxy.$modal.confirm('是否确认删除储存过程步骤分布处理日志编号为"' + _procedureNames + '"的数据项？').then(function() {
      return delProcedure(_procedureNames)
    }).then(() => {
      getList()
      proxy.$modal.msgSuccess("删除成功")
    }).catch(() => {})
  }

  /** 导出按钮操作 */
  function handleExport() {
    proxy.download('system/procedure/export', {
      ...queryParams.value
    }, `procedure_${new Date().getTime()}.xlsx`)
  }

  getList()
</script>
